Enterprise Database Systems
The Cypher Query Language
Cypher Query Language: Advanced Operations with Cypher
it_dacyqldj_03_enus
Cypher Query Language: Basic Reads & Writes with Cypher
it_dacyqldj_02_enus
Cypher Query Language: Creating Nodes & Relationships with Cypher
it_dacyqldj_01_enus
Cypher Query Language: Advanced Operations with Cypher
Lesson Objectives
Cypher Query Language: Advanced Operations with Cypher
- discover the key concepts covered in this course
- provision multiple nodes and relationships in a Neo4j database using the MERGE clause
- use the Cypher query language to look for 2nd degree and higher degree connections between two nodes in a Neo4j database
- use the shortestPath function of the Cypher query language to retrieve the shortest path between nodes
- filter the data returned by a Cypher query by specifying filtering criteria in the WHERE clause
- perform union and intersect operations on data in a Neo4j database using the Cypher query language
- use Cypher's aggregate functions to operate on string and numeric data in a Neo4j database
- sort the results of a query execution using the ORDER BY clause
- summarize the key concepts covered in this course
Overview/Description
This course explores a variety of Cypher queries that go beyond simple reads and writes. The course also involves identifying complex patterns and combinations of data in nodes and relationships. Begin with a deep dive into querying for patterns in relationships. Move on to the operation of finding the shortest paths between two nodes in a graph structure. Next, explore queries based on the properties of nodes or relationships, where you will look for elements matching a single criterion as well as multiple criteria defined using logical operations. Following that, explore some of the fundamental aggregation operations which can be performed on data using the Cypher language on both text and numeric data. Finally, discover how to order query results and limit their size using the LIMIT and SKIP clauses. Upon completion, you'll know how to apply graph-specific and generic database features to analyze a Neo4j database using the Cypher language.
This course explores a variety of Cypher queries that go beyond simple reads and writes. The course also involves identifying complex patterns and combinations of data in nodes and relationships. Begin with a deep dive into querying for patterns in relationships. Move on to the operation of finding the shortest paths between two nodes in a graph structure. Next, explore queries based on the properties of nodes or relationships, where you will look for elements matching a single criterion as well as multiple criteria defined using logical operations. Following that, explore some of the fundamental aggregation operations which can be performed on data using the Cypher language on both text and numeric data. Finally, discover how to order query results and limit their size using the LIMIT and SKIP clauses. Upon completion, you'll know how to apply graph-specific and generic database features to analyze a Neo4j database using the Cypher language.
Target
Prerequisites: none
Cypher Query Language: Basic Reads & Writes with Cypher
Lesson Objectives
Cypher Query Language: Basic Reads & Writes with Cypher
- discover the key concepts covered in this course
- execute queries involving the creation of multiple Neo4j elements
- use the MATCH clause in a Cypher query to search for different types of patterns in relationships
- apply a variety of MATCH and OPTIONAL MATCH operations when searching for patterns
- use the SET and REMOVE clauses in a Cypher query in order to update nodes
- recognize the use cases of the MERGE clause of a Cypher query
- remove unwanted nodes and relationships in a Neo4j graph
- summarize the key concepts covered in this course
Overview/Description
This course introduces you to the breadth of operations which can be performed using the Cypher query language to add, modify, and delete nodes and relationships. Kick things off with queries that create multiple nodes and relationships in a single operation. Move on to MATCH queries where you search for relationships based on a variety of different patterns. Then, delve into the OPTIONAL MATCH clause to search based on partial pattern matches. Next, discover how to update operations where node properties are created, changed, or removed. Explore the MERGE clause in the Cypher language. This clause is similar to the CREATE clause but has a few notable differences that make it the better choice in many scenarios. Finally, learn how nodes and relationships in Neo4j can be removed and some of the rules around such operations. After completing this course you'll be able to add, modify, and delete nodes and relationships in a Neo4j database using the Cypher query language.
This course introduces you to the breadth of operations which can be performed using the Cypher query language to add, modify, and delete nodes and relationships. Kick things off with queries that create multiple nodes and relationships in a single operation. Move on to MATCH queries where you search for relationships based on a variety of different patterns. Then, delve into the OPTIONAL MATCH clause to search based on partial pattern matches. Next, discover how to update operations where node properties are created, changed, or removed. Explore the MERGE clause in the Cypher language. This clause is similar to the CREATE clause but has a few notable differences that make it the better choice in many scenarios. Finally, learn how nodes and relationships in Neo4j can be removed and some of the rules around such operations. After completing this course you'll be able to add, modify, and delete nodes and relationships in a Neo4j database using the Cypher query language.
Target
Prerequisites: none
Cypher Query Language: Creating Nodes & Relationships with Cypher
Lesson Objectives
Cypher Query Language: Creating Nodes & Relationships with Cypher
- discover the key concepts covered in this course
- describe the use cases as well as the basic syntax of the Cypher query language
- set up Neo4j Desktop on your system and provision a database management system
- recognize the syntax as well as the effect of the CREATE clause in a Cypher query
- provision nodes with labels as well as properties using the CREATE clause in a Cypher query
- set up relationships between nodes in a Neo4j database
- define relationships which have their own properties using the Cypher language
- summarize the key concepts covered in this course
Overview/Description
This first course in the path delves into the basics of the Cypher query language. You will learn about the creation of nodes, relationships between nodes, and how to search for simple patterns among them. Begin with a simple query with a CREATE clause in order to create a node. Build upon your query at each step, starting with an empty node, then creating nodes with properties and nodes containing one or more labels. You then move on to setting relationships between nodes. Define relationships between existing nodes in the database, and build nodes containing their own properties. All the while, gaining familiarity with the syntax of CREATE queries in the Cypher query language, how directions are set when defining relationships, and the rules and conventions around names for node labels and relationships. After completion of this course you'll know how to create nodes and relationships between nodes in a Neo4j database using the Cypher query language.
This first course in the path delves into the basics of the Cypher query language. You will learn about the creation of nodes, relationships between nodes, and how to search for simple patterns among them. Begin with a simple query with a CREATE clause in order to create a node. Build upon your query at each step, starting with an empty node, then creating nodes with properties and nodes containing one or more labels. You then move on to setting relationships between nodes. Define relationships between existing nodes in the database, and build nodes containing their own properties. All the while, gaining familiarity with the syntax of CREATE queries in the Cypher query language, how directions are set when defining relationships, and the rules and conventions around names for node labels and relationships. After completion of this course you'll know how to create nodes and relationships between nodes in a Neo4j database using the Cypher query language.
Target
Prerequisites: none
